package Member;

import java.util.HashMap;
import java.util.List;

import org.apache.ibatis.annotations.Param;


public interface MemberMapper {
	HashMap<String,Object> selectById(String id);
	List<MemberItem> selectAll();
	void insertStudent(MemberItem item);
	
	void insertPro(MemberItem item);
	
	void insertMaster(MemberItem item);
	
	List<HashMap<String,Object>> selectTeamMemberSearch(@Param("str") String str,@Param("temp") String temp, @Param("track_id") int track_id,@Param("contest_reg_id") int contest_reg_id);
	int selectCount(@Param("tt") String tt,@Param("ct") String ct,@Param("ct2") String ct2);
	List<MemberItem> selectPage(@Param("pg") int pg,@Param("sz") int sz,@Param("tt") String tt,@Param("ct") String ct,@Param("ct2") String ct2);
	
	
	MemberItem selectLogin(@Param("id") String id,@Param("password") String password);
	
	MemberItem selectMemberUser(@Param("id") String id,@Param("contest_reg_id") int contest_reg_id);
	
	List<MemberItem> selectStu();
	List<MemberItem> selectPro();
	List<MemberItem> selectAdmin();
	
	List<MemberItem> selectNoUserContest_reg(@Param("contest_reg_id") int contest_reg_id);
	List<MemberItem> selectNoUserTrack(@Param("contest_reg_id") int contest_reg_id , @Param("track_id") int track_id);
	
	List<MemberItem> selectUserNameTrack(@Param("name") String name,@Param("contest_reg_id") int contest_reg_id,@Param("track_id") int track_Id);
	List<MemberItem> selectUserNameTrack2(@Param("name") String name,@Param("contest_reg_id") int contest_reg_id,@Param("track_id") int track_Id,@Param("team_id") int team_id);
	
	
	List<MemberItem> selectUserIdTrack(@Param("id") String id,@Param("contest_reg_id") int contest_reg_id,@Param("track_id") int track_Id);
	List<MemberItem> selectUserIdTrack2(@Param("id") String id,@Param("contest_reg_id") int contest_reg_id,@Param("track_id") int track_Id,@Param("team_id") int team_id);
	List<MemberItem> selectUserIdTrack3(@Param("id") String id,@Param("contest_reg_id") int contest_reg_id,@Param("track_id") int track_Id);
	
	List<MemberItem> selectUserNameContest_reg(@Param("name") String name,@Param("contest_reg_id") int contest_reg_id);
	List<MemberItem> selectUserNameContest_reg2(@Param("name") String name,@Param("contest_reg_id") int contest_reg_id,@Param("team_id") int team_id);
	
	List<MemberItem> selectUserIdContest_reg(@Param("id") String id,@Param("contest_reg_id") int contest_reg_id);
	List<MemberItem> selectUserIdContest_reg2(@Param("id") String id,@Param("contest_reg_id") int contest_reg_id,@Param("team_id") int team_id);
	List<MemberItem> selectUserIdContest_reg3(@Param("id") String id,@Param("contest_reg_id") int contest_reg_id);
	
	void updateInfo(MemberItem member);
	void updatePasswd(MemberItem member);
	
	

}